{
    "__default": {
        "session": {
            "counter": 14,
            "timer": {
                "start": 1790036883,
                "last": 1790036886,
                "now": 1790036886
            },
            "token": "QygH4cZJmolZFypQxD42z7L0L6xRSPna"
        },
        "registry": {
            "com_virtuemart": {
                "category": {
                    "limit": "12"
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "de-DE"
        },
        "com_mailto": {
            "links": {
                "8335bbf49ba9703fcb0dcee0a334f965e7ba1dcf": {
                    "link": "https://cachaca-online.de/de/events-jahresuebersicht/Monatskalender/2021/9/-",
                    "expiry": 1790036886
                },
                "58e7829f63bd8ebde9bc668dd89bf2374feda6a9": {
                    "link": "https://cachaca-online.de/de/events-jahresuebersicht/Wochen\u00fcbersicht/2021/5/24/-",
                    "expiry": 1790036886
                }
            }
        }
    },
    "__vm": {
        "vmlastvisitedItemid": 125,
        "vmlastvisitedcategoryid": 1,
        "vmlastvisitedmanuid": 0,
        "vmcartlastVendorId": 1,
        "vmcart": "{\"cartProductsData\":[],\"vendorId\":1,\"lastVisitedCategoryId\":0,\"virtuemart_shipmentmethod_id\":0,\"virtuemart_paymentmethod_id\":0,\"automaticSelectedShipment\":false,\"automaticSelectedPayment\":false,\"order_number\":null,\"BT\":[],\"ST\":{\"address_type_name\":\"Adresse Kurzbezeichnung\"},\"cartfields\":[],\"couponCode\":\"\",\"_triesValidateCoupon\":[],\"order_language\":\"de-DE\",\"pricesCurrency\":null,\"paymentCurrency\":null,\"_guest\":1,\"_inCheckOut\":false,\"_inConfirm\":false,\"_redirected\":false,\"_dataValidated\":false,\"_confirmDone\":false,\"STsameAsBT\":1,\"selected_shipto\":0,\"_fromCart\":false,\"layout\":\"default\",\"layoutPath\":\"\",\"virtuemart_cart_id\":0,\"OrderIdOrderDone\":false,\"orderdoneHtml\":false,\"virtuemart_order_id\":false,\"byDefaultBT\":[],\"byDefaultST\":{\"address_type_name\":1},\"productCartLoaded\":[],\"loadedCart\":true,\"lastAddedProduct\":0}"
    }
}

Zeit

Speicher

21 ausgeführte Abfragen 20.26 ms

1. Abfragezeit: 0.57 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.060 MB Zeilen zurückgegeben: 1

   SELECT `session_id`
   
     FROM `jos_session`
   
     WHERE `session_id` = X'3763363437326365343634366531393736353531343230393237306536323634' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   Profil (Profile)

   Status	Duration
   starting	0.12 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.03 ms
   statistics	0.08 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

2. Abfragezeit: 0.38 ms Nach letzter Abfrage: 2.02 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.142 MB Zeilen zurückgegeben: 5

   SELECT id, rules
   
     FROM `jos_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_viewlevels	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	100.00	NULL

   Profil (Profile)

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.06 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

3. Abfragezeit: 0.48 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.153 MB Zeilen zurückgegeben: 2

   SELECT b.id
   
     FROM jos_usergroups AS a
   
     LEFT JOIN jos_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

   Profil (Profile)

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.13 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

4. Abfragezeit: 0.87 ms Nach letzter Abfrage: 25.21 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.409 MB

   UPDATE `jos_extensions`
   
     SET `params` = '{\"mediaversion\":\"dfc67e0608ce83e30b7d8803429974a0\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	UPDATE	jos_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.15 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   init	0.05 ms
   System lock	0.17 ms
   updating	0.14 ms
   end	0.02 ms
   query end	0.08 ms
   closing tables	0.02 ms
   freeing items	0.04 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

5. Abfragezeit: 1.52 ms Nach letzter Abfrage: 8.67 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.641 MB Zeilen zurückgegeben: 38

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `jos_assets`
   
     WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_privacy','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper')

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_assets	NULL	ALL	idx_asset_name	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	121	32.23	Using where

   Profil (Profile)

   Status	Duration
   starting	0.17 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.15 ms
   System lock	0.03 ms
   optimizing	0.02 ms
   statistics	0.26 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.53 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.04 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   12	Joomla\CMS\User\User->authorise()	JROOT/components/com_jevents/libraries/helper.php:1428
   11	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1386
   10	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:50
   9	JEventsDataModel->__construct()	JROOT/administrator/components/com_jevents/controllers/icals.php:49
   8	AdminIcalsController->__construct()	JROOT/components/com_jevents/controllers/icals.php:34
   7	ICalsController->__construct()	JROOT/components/com_jevents/jevents.php:311
   6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

6. Abfragezeit: 0.70 ms Nach letzter Abfrage: 2.70 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 2.684 MB Zeilen zurückgegeben: 1

   SELECT language,id
   
     FROM `jos_menu`
   
     WHERE home = 1 
     AND published = 1 
     AND client_id = 0

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	52	1.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.10 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.03 ms
   statistics	0.07 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.19 ms
   end	0.01 ms
   query end	0.02 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
   8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
   7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
   6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

7. Abfragezeit: 0.55 ms Nach letzter Abfrage: 2.40 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.724 MB Zeilen zurückgegeben: 1

   SELECT * 
     FROM jos_template_styles 
     WHERE template = 'shape5_vertex';

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_template_styles	NULL	ref	idx_template	idx_template	202	const	1	100.00	NULL

   Profil (Profile)

   Status	Duration
   starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   init	0.05 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.06 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   10	JDatabaseDriver->loadAssocList()	JROOT/templates/shape5_vertex/vertex/parameters.php:20
   9	getTemplateName()	JROOT/templates/shape5_vertex/vertex/parameters.php:169
   8	require JROOT/templates/shape5_vertex/vertex/parameters.php	JROOT/templates/shape5_vertex/index.php:32
   7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
   6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
   5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
   4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
   3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
   2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

8. Abfragezeit: 0.84 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.089 MB Speichernutzung vor Abfrage: 2.731 MB Zeilen zurückgegeben: 51

   SELECT * 
     FROM jos_menu 
     WHERE template_style_id = 10

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_menu	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	113	10.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.52 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   10	JDatabaseDriver->loadAssocList()	JROOT/templates/shape5_vertex/vertex/parameters.php:45
   9	getTemplateName()	JROOT/templates/shape5_vertex/vertex/parameters.php:169
   8	require JROOT/templates/shape5_vertex/vertex/parameters.php	JROOT/templates/shape5_vertex/index.php:32
   7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
   6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
   5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
   4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
   3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
   2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

9. Abfragezeit: 2.54 ms Nach letzter Abfrage: 17.12 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 3.743 MB Zeilen zurückgegeben: 1

   SHOW TABLES LIKE "jos_virtuemart_configs"

   Explain

   „EXPLAIN“ unmöglich für Abfrage: SHOW TABLES LIKE "jos_virtuemart_configs"

   Profil (Profile)

   Status	Duration
   starting	0.10 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.06 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.01 ms
   checking permissions	1.95 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   removing tmp table	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   24	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/vmtable.php:820
   23	VmTable::checkTableExists()	JROOT/administrator/components/com_virtuemart/models/config.php:590
   22	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:405
   21	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:196
   20	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:309
   19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
   18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
   17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
   16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
   15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
   14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
   13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
   12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
   11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
   10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
   9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
   8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
   7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
   6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
   5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
   4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
   3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
   2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

   ---

10. Abfragezeit: 0.44 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.755 MB Zeilen zurückgegeben: 1

    SELECT `config` 
      FROM `jos_virtuemart_configs` 
      WHERE `virtuemart_config_id` = "1";

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_virtuemart_configs	NULL	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:454
    21	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:196
    20	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:309
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

11. Abfragezeit: 1.41 ms Nach letzter Abfrage: 2.05 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 3.835 MB Zeilen zurückgegeben: 11

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and (language="*" or language = "de-DE" )  
      AND client_id=0 
      AND published=1 
      AND ( access="1" OR access="5" )  
      and `menutype` = (SELECT `menutype` 
      FROM `jos_menu` 
      WHERE `id` = "125")  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	const	34	0.88	Using index condition; Using where; filesort wurde genutzt
    2	SUBQUERY	jos_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.09 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    statistics	0.14 ms
    preparing	0.05 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.54 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1661
    22	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:290
    21	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:262
    20	vmrouterHelper::init()	JROOT/components/com_virtuemart/router.php:309
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

12. Abfragezeit: 1.03 ms Nach letzter Abfrage: 1.02 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 3.946 MB Zeilen zurückgegeben: 11

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and (language="*" or language = "de-DE" )  
      AND client_id=0 
      AND published=1 
      AND ( access="1" OR access="5" )  
      and `menutype` = (SELECT `menutype` 
      FROM `jos_menu` 
      WHERE `id` = "603")  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	const	34	0.88	Using index condition; Using where; filesort wurde genutzt
    2	SUBQUERY	jos_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.08 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    statistics	0.10 ms
    preparing	0.05 ms
    Sorting result	0.03 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.37 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1661
    21	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:290
    20	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:329
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

13. Abfragezeit: 1.03 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 3.969 MB Zeilen zurückgegeben: 11

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and (language="*" or language = "de-DE" )  
      AND client_id=0 
      AND published=1 
      AND ( access="1" OR access="5" )  
      and `menutype` = (SELECT `menutype` 
      FROM `jos_menu` 
      WHERE `id` = "204")  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	const	34	0.88	Using index condition; Using where; filesort wurde genutzt
    2	SUBQUERY	jos_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    statistics	0.09 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.38 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1661
    21	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:290
    20	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:329
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

14. Abfragezeit: 1.00 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 3.993 MB Zeilen zurückgegeben: 11

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and (language="*" or language = "de-DE" )  
      AND client_id=0 
      AND published=1 
      AND ( access="1" OR access="5" )  
      and `menutype` = (SELECT `menutype` 
      FROM `jos_menu` 
      WHERE `id` = "205")  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	const	34	0.88	Using index condition; Using where; filesort wurde genutzt
    2	SUBQUERY	jos_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    statistics	0.08 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.40 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1661
    21	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:290
    20	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:329
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

15. Abfragezeit: 0.98 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 4.015 MB Zeilen zurückgegeben: 11

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and (language="*" or language = "de-DE" )  
      AND client_id=0 
      AND published=1 
      AND ( access="1" OR access="5" )  
      and `menutype` = (SELECT `menutype` 
      FROM `jos_menu` 
      WHERE `id` = "756")  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	const	34	0.88	Using index condition; Using where; filesort wurde genutzt
    2	SUBQUERY	jos_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.36 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1661
    21	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:290
    20	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:329
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

16. Abfragezeit: 0.99 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 4.037 MB Zeilen zurückgegeben: 11

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and (language="*" or language = "de-DE" )  
      AND client_id=0 
      AND published=1 
      AND ( access="1" OR access="5" )  
      and `menutype` = (SELECT `menutype` 
      FROM `jos_menu` 
      WHERE `id` = "757")  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	const	34	0.88	Using index condition; Using where; filesort wurde genutzt
    2	SUBQUERY	jos_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.37 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1661
    21	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:290
    20	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:329
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

17. Abfragezeit: 0.99 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.051 MB Speichernutzung vor Abfrage: 4.067 MB Zeilen zurückgegeben: 11

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and (language="*" or language = "de-DE" )  
      AND client_id=0 
      AND published=1 
      AND ( access="1" OR access="5" )  
      and `menutype` = (SELECT `menutype` 
      FROM `jos_menu` 
      WHERE `id` = "206")  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	const	34	0.88	Using index condition; Using where; filesort wurde genutzt
    2	SUBQUERY	jos_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    statistics	0.10 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.42 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1661
    21	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:290
    20	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:329
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

18. Abfragezeit: 0.95 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 4.090 MB Zeilen zurückgegeben: 11

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and (language="*" or language = "de-DE" )  
      AND client_id=0 
      AND published=1 
      AND ( access="1" OR access="5" )  
      and `menutype` = (SELECT `menutype` 
      FROM `jos_menu` 
      WHERE `id` = "207")  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	const	34	0.88	Using index condition; Using where; filesort wurde genutzt
    2	SUBQUERY	jos_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.33 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1661
    21	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:290
    20	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:329
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

19. Abfragezeit: 0.93 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 4.112 MB Zeilen zurückgegeben: 11

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and (language="*" or language = "de-DE" )  
      AND client_id=0 
      AND published=1 
      AND ( access="1" OR access="5" )  
      and `menutype` = (SELECT `menutype` 
      FROM `jos_menu` 
      WHERE `id` = "208")  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	const	34	0.88	Using index condition; Using where; filesort wurde genutzt
    2	SUBQUERY	jos_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    statistics	0.08 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.34 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1661
    21	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:290
    20	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:329
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

20. Abfragezeit: 1.00 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 4.134 MB Zeilen zurückgegeben: 11

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and (language="*" or language = "de-DE" )  
      AND client_id=0 
      AND published=1 
      AND ( access="1" OR access="5" )  
      and `menutype` = (SELECT `menutype` 
      FROM `jos_menu` 
      WHERE `id` = "209")  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	const	34	0.88	Using index condition; Using where; filesort wurde genutzt
    2	SUBQUERY	jos_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    statistics	0.08 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.40 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1661
    21	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:290
    20	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:329
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

21. Abfragezeit: 1.06 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.050 MB Speichernutzung vor Abfrage: 4.157 MB Zeilen zurückgegeben: 11

    SELECT * 
      FROM `jos_menu` 
      WHERE `link` like "index.php?option=com_virtuemart%" 
      and (language="*" or language = "de-DE" )  
      AND client_id=0 
      AND published=1 
      AND ( access="1" OR access="5" )  
      and `menutype` = (SELECT `menutype` 
      FROM `jos_menu` 
      WHERE `id` = "210")  
      ORDER BY `language` DESC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype,idx_language	idx_menutype	98	const	34	0.88	Using index condition; Using where; filesort wurde genutzt
    2	SUBQUERY	jos_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    statistics	0.08 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.46 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1661
    21	vmrouterHelper::setMenuItemId()	JROOT/components/com_virtuemart/router.php:290
    20	vmrouterHelper::setRoutingQuery()	JROOT/components/com_virtuemart/router.php:329
    19	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:104
    18	virtuemartBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:195
    10	S5modMainMenuHelper::getList()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/helpers.php:274
    9	S5modMainMenuHelper::S5buildXML()	JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php:54
    8	include JROOT/templates/shape5_vertex/vertex/s5flex_menu/default.php	JROOT/templates/shape5_vertex/index.php:168
    7	require JROOT/templates/shape5_vertex/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

    ---

11 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

1. 11 × SELECT * 
     FROM `jos_menu`

2. 1 × SELECT `session_id` 
     FROM `jos_session`

3. 1 × SELECT id, rules 
     FROM `jos_viewlevels

4. 1 × SELECT b.id 
     FROM jos_usergroups AS a 
     LEFT JOIN jos_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt

5. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `jos_assets`

6. 1 × SELECT language,id 
     FROM `jos_menu`

7. 1 × SELECT * 
     FROM jos_template_styles

8. 1 × SELECT * 
     FROM jos_menu

9. 1 × SELECT `config` 
     FROM `jos_virtuemart_configs`

Andere Tabellen:

1. 1 × UPDATE `jos_extensions` 
     SET `params` = '{\"mediaversion\":\"dfc67e0608ce83e30b7d8803429974a0\"}'

2. 1 × SHOW TABLES LIKE "jos_virtuemart_configs